OT: order by u Oracle
Otázka od: Jiri Foldyna
19. 11. 2002 15:58
Ahoj,
neni zde nekdo, kdo by umel vysvetlit, jak Oracle tridi char ?
Mam nadefinovany sloupec zm_pftime jako char(16), ukladam do nej Int64
prevedeny do 16-znakoveho hexa stringu.
1. Dotaz SELECT zm_pftime FROM tbl_zmeny ORDER BY zm_pftime DESC vrati
ZM_PFTIME
----------------
000171B3B8B3A918
000171B3B8B3A917
000171B3BDD2D36F *** spatne zatrideno
000171B3A9E6782B
000171B3A733E183
000171B3A189D2AE
000171B3AD0EDAB6 *** spatne zatrideno
2. Dotaz SELECT zm_pftime FROM tbl_zmeny ORDER BY zm_pftime ASC vrati
ZM_PFTIME
----------------
000171B3AD0EDAB6 *** spatne zatrideno
000171B3A189D2AE
000171B3A733E183
000171B3A9E6782B
000171B3BDD2D36F *** spatne zatrideno
000171B3B8B3A917
000171B3B8B3A918
Nevite nekdo, kde by mohl byt zakopany pes ?
Diky
Jiri Foldyna
mailto:jiri.f@avizo.cz
Odpovedá: ViragI@logica.com
19. 11. 2002 16:36
Jak je na klientovi nastaven parametr NLS_SORT?
Ivan Virag
>
neni zde nekdo, kdo by umel vysvetlit, jak Oracle tridi char ?
Mam nadefinovany sloupec zm_pftime jako char(16), ukladam do nej Int64
prevedeny do 16-znakoveho hexa stringu.
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.
Odpovedá: Jiri Foldyna
19. 11. 2002 17:20
> Jak je na klientovi nastaven parametr NLS_SORT?
> Ivan Virag
Default, nls_language = AMERICAN.
Jiri Foldyna
mailto:jiri.f@avizo.cz